﻿ALTER TABLE [dbo].[Room]
	ADD CONSTRAINT [RoomToRoomState] 
	FOREIGN KEY ([RoomStateId])
	REFERENCES [dbo].[RoomState] ([Id])
	ON UPDATE CASCADE
	ON DELETE CASCADE
